Total execution time: 1716201383.1795 sec.
Framework 1.50 v3.00
Cpu Usage 9445 sec.
Memory Usage 803.65kB
POST:
Array
(
)
GET:
Array
(
[order] => mileage|DESC
)
1. select |
total: 1SELECT * FROM `settings` WHERE (`id` = 1) ;
2. count |
total: 7SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;
3. SELECT |
total: 7 SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.title, l.gallery, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured, li.feature_name, li.location_name FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY mileage DESC LIMIT 0,30; ;
4. select |
total: 8SELECT id, name FROM `categories`;
5. SELECT |
total: 0SELECT * FROM `advert` ORDER BY RAND() LIMIT 1;
6. SELECT |
total: 2 SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;
1. select | total: 1. SELECT * FROM `settings` WHERE (`id` = 1) ;
2. count | total: 0. SELECT COUNT(*) AS items FROM `listings` AS l LEFT JOIN `listings_info` li ON l.id = li.listing_id WHERE li.lstatus = 1 AND li.make_slug = 'subaru' AND li.color_name = 'silver';
3. SELECT | total: 0. SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.gallery, l.title, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 AND li.make_slug = 'subaru' AND li.color_name = 'silver' ORDER BY created DESC;
4. SELECT | total: 2. SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;
2. count | total: 7. SELECT COUNT(*) AS items FROM `listings` WHERE (`status` = 1) ;
3. SELECT | total: 7. SELECT li.model_name, li.condition_name, li.category_name, li.trans_name, li.fuel_name, li.color_name, l.id, l.thumb, l.idx, l.doors, l.nice_title, l.title, l.gallery, l.slug, l.price, l.price_sale, l.year, l.sold, l.engine, l.top_speed, l.created, l.mileage, l.featured, li.feature_name, li.location_name FROM `listings` AS l LEFT JOIN `listings_info` AS li ON l.id = li.listing_id WHERE l.status = 1 ORDER BY mileage DESC LIMIT 0,30; ;
4. select | total: 8. SELECT id, name FROM `categories`;
5. SELECT | total: 0. SELECT * FROM `advert` ORDER BY RAND() LIMIT 1;
6. SELECT | total: 2. SELECT m.id, m.name, m.content_type, m.link, m.target, p.slug, p.type FROM `menus` AS m LEFT JOIN `pages` AS p ON p.id = m.page_id WHERE m.active = 1 ORDER BY m.sorting;